'''
Created on 2011-1-10

@author: zarra
'''

from sqlalchemy import  Column, Integer, String,Unicode,UnicodeText, DateTime
from model.expr_a._base import Base,expr_a

class Bljy(Base):
    __tablename__ = 'expr_bljy'
    id             = Column('jl_id',String(16),nullable=False,primary_key=True)
    expr_id        = Column('expr_idj',String(16),nullable=False)
    apply_time     = Column('sq_sj',DateTime,nullable=False)
    doctor_id      = Column('yh_id',String(16),nullable=False)
    department_id  = Column('ks_id',String(16),nullable=False)
    type           = Column('bljy_lx',String(1),nullable=False)
    reason         = Column('bljy_md',UnicodeText)
    is_approval    = Column('is_sp',String(1),nullable=False)
    approval_time  = Column('sp_sj',DateTime,nullable=False)
    end_time       = Column('bljy_sx',DateTime,nullable=False)